Problem Note 45205: The DB2UTIL procedure inserts garbage characters into CHAR and VARCHAR variables
If you use the DB2UTIL procedure (PROC DB2UTIL) to insert new rows into an existing DB2 table, an incorrect value might be stored in the DB2 table. This occurs when the DB2 table contains variables defined as CHAR or VARCHAR and those variables have a length greater than 200. PROC DB2UTIL might put garbage characters in the value it is passing to DB2 somewhere after the 200th character.
To work around this issue, use the LIBNAME engine and insert the rows using either the SQL or APPEND procedure.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2012-01-02 14:16:49 |
| Date Created: | 2011-12-21 11:59:02 |
